from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, VARCHAR, INTEGER, DateTime,Date

from app.settings import engine

Base = declarative_base()
meta = Base.metadata

class Province(Base):
    __tablename__ = 'province'
    id = Column(INTEGER,primary_key=True,autoincrement=True)
    name = Column(VARCHAR(32))
    nowConfirm = Column(INTEGER)
    confirm = Column(INTEGER)
    update_time = Column(Date)

if __name__ == '__main__':
    meta.create_all(engine)